package com.sc.mapper.mapperauto;

import java.util.List;

import com.sc.pojo.AppointmentEC;

public interface AppointmentECMapper {
    int deleteByPrimaryKey(Integer lid);

    int insert(AppointmentEC record);

    int insertSelective(AppointmentEC record);

    AppointmentEC selectByPrimaryKey(Integer lid);

    int updateByPrimaryKeySelective(AppointmentEC record);

    int updateByPrimaryKeyWithBLOBs(AppointmentEC record);

    int updateByPrimaryKey(AppointmentEC record);

    // 查询一个客户预约完成记录
    List<AppointmentEC> selectAppByLapp(Integer cid);

    // 查询所有客户预约完成记录
    List<AppointmentEC> selectAppAll();

    // 查询所有客户预约处理记录
    List<AppointmentEC> selectByAll();

    // 查询一个客户预约处理记录
    List<AppointmentEC> selectByCid(Integer cid);

    /**
     * 查询当天所有员工销售额，销售房屋套数，销售面积
     */
    List<AppointmentEC> queryGetMoneyAndCountAndAreaByDay();

    /**
     * 查询当周所有员工销售额，销售房屋套数，销售面积
     */
    List<AppointmentEC> queryGetMoneyAndCountAndAreaByWeek();

    /**
     * 查询当月所有员工销售额，销售房屋套数，销售面积
     */
    List<AppointmentEC> queryGetMoneyAndCountAndAreaByMonth();

}